package com.gxan.dao;

import com.gxan.pojo.SalStandard;

import java.sql.SQLException;
import java.util.List;

public interface StandardDao {
    //    查询薪酬标准表所有内容
    List<SalStandard> queryStandardList(Integer offset, Integer rows) throws SQLException;

    //薪酬标准表计数查询
    Integer countStandard() throws SQLException;

    //薪酬标准添加
    int addStandardList(SalStandard salStandard) throws SQLException;

    //修改标准
    int updateStandard(SalStandard salStandard) throws SQLException;
    //复核
    int reviewStandard(SalStandard salStandard) throws SQLException;
    //变更
    int changeStandard(SalStandard salStandard) throws SQLException;
    //明细
    int detailsStandard(SalStandard salStandard) throws SQLException;
    //删除
    int deleteStandard(String sal_standard_code) throws SQLException;
    //搜索
    List<SalStandard> searchStandard(Integer offset,Integer rows,String sal_standard_name,Integer review_status) throws SQLException;
    //搜索总条数
    int countSearchStandard(String sal_standard_name,Integer review_status) throws SQLException;
}
